<?php
require_once '../includes/dbcon.php';

header('Content-Type: application/json');

// Check if student ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    echo json_encode(['success' => false, 'message' => 'Student ID is required.']);
    exit;
}

$student_id = intval($_GET['id']);

try {
    // Fetch student details
    $stmt = $DBcon->prepare("
        SELECT * FROM students 
        WHERE id = :id
    ");
    $stmt->bindParam(':id', $student_id);
    $stmt->execute();
    
    $student = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if ($student) {
        echo json_encode([
            'success' => true,
            'data' => $student
        ]);
    } else {
        echo json_encode([
            'success' => false,
            'message' => 'Student not found.'
        ]);
    }
    
} catch (PDOException $e) {
    error_log("Database error in get_student_profile: " . $e->getMessage());
    echo json_encode([
        'success' => false,
        'message' => 'Database error occurred.'
    ]);
}
?>